Overview: Time Manipulation

Use this operation to change the times of your timestamp by either offsetting or warping the timestamp.

Offsetting: adjusting the timestamp by a set period. You can offset the timestamp by days, hours, seconds and fractions of seconds. e.g.: 23 12:30:24.8. This will offset the timestamp by 23 days, 12 hours, 30 minutes, 24 seconds and 8 milliseconds.

Warping: Using warping to manipulate the time will enable you to define a different start and end time; the timestamps will then be changed to fit between the newly selected start and end time.

Note:
- The number of rows will never change, only the timestamps will be modified in the current dataset.
- If the original dataset had a time span of 1 month, and you warp it to 3 months, it will have that same data over 3 months (index will not change). The chronological order of the data, and the ratio between the data points, will remain constant, it will simply be extrapolated over 3 months.
- If you keep the time span to one month warped to a different start date, the timestamp date will change, but the original time values will be kept.

Properties

Category:	Modify
Performance risk:	High potential performance risk. The performance is influenced by the size of the text file being imported, which is determined by number of rows and/or the number of columns of the dataset.
Knowledge required:	Working knowledge of the software.

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	No
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	No
Does it modify the current dataset in any way?	Yes

Requirements

A dataset with a timestamp field.

Results

A modified dataset where the date and time of the timestamp field are modified to the newly defined date and time.